-- =========================================
-- Author: Jacob Gable
-- Created: 02.00.2009
-- Notes: Creation of TrainerClient table.
-- 
-- 
-- =========================================

IF OBJECT_ID('dbo.TrainerClient', 'U') IS NOT NULL
  DROP TABLE dbo.TrainerClient
GO

CREATE TABLE dbo.TrainerClient
(
	TrainerID uniqueidentifier
		FOREIGN KEY REFERENCES aspnet_Users (UserId)
		ON DELETE CASCADE NOT NULL, 
	ClientID uniqueidentifier
		FOREIGN KEY REFERENCES aspnet_Users (UserId),		
	ts timestamp NULL    
)
GO
